find the all column with schema for any table in sql server

Varun Agrawal249825-Mar-2011

How to find all column with schema for any table in sql server.
please give the example.
thanks in advance

Updated on 09-Apr-2013

Can you answer this question?

Answer

09-Apr-2013

Hi Varun,

Alternatively you can try,

SP_HELP EMP in SQL Server

Here EMP is the table name

Thanks,

Shankar

26-Mar-2011

Hi Varun,

You can try this to find all column with schema for any table in sql server.

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=’table_name’

forum